AsposeCharts.java

/**
 * Copyright (c) Aspose 2002-2014. All Rights Reserved.
 *
 * LICENSE: This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 3
 * of the License, or (at your option) any later version.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://opensource.org/licenses/gpl-3.0.html>;.
 *
 * @author  Shoaib Khan <shoaib.khan@aspose.com>
 * @link    https://github.com/asposemarketplace/Aspose_for_Apache_POI
 */

package asposefeatures.workingwithcharts.createcharts.java;

import java.awt.Color;

import com.aspose.slides.ChartType;
import com.aspose.slides.FillType;
import com.aspose.slides.IChart;
import com.aspose.slides.IChartDataWorkbook;
import com.aspose.slides.IChartSeries;
import com.aspose.slides.IDataLabel;
import com.aspose.slides.ISlide;
import com.aspose.slides.NullableBool;
import com.aspose.slides.Presentation;
import com.aspose.slides.SaveFormat;

public class AsposeCharts
{
    public static void main(String[] args) throws Exception
    {
	String dataPath = "src/asposefeatures/workingwithcharts/createcharts/data/";
	
	// Instantiate Presentation class that represents PPTX file//Instantiate
	// Presentation class that represents PPTX file
	Presentation pres = new Presentation();

	// Access first slide
	ISlide sld = pres.getSlides().get_Item(0);

	// Add chart with default data
	IChart chart = sld.getShapes().addChart(ChartType.ClusteredColumn, 0, 0, 500, 500);

	// Setting chart Title
	// chart.ChartTitle.TextFrameForOverriding.Text = "Sample Title";
	chart.getChartTitle().addTextFrameForOverriding("Sample Title");
	chart.getChartTitle().getTextFrameForOverriding().getTextFrameFormat()
		.setCenterText(NullableBool.True);
	chart.getChartTitle().setHeight(20);
	chart.hasTitle(true);

	// Set first series to Show Values
	chart.getChartData().getSeries().get_Item(0).getLabels().getDefaultDataLabelFormat()
		.setShowValue(true);

	// Setting the index of chart data sheet
	int defaultWorksheetIndex = 0;

	// Getting the chart data worksheet
	IChartDataWorkbook fact = chart.getChartData().getChartDataWorkbook();

	// Delete default generated series and categories
	chart.getChartData().getSeries().clear();
	chart.getChartData().getCategories().clear();
	int s = chart.getChartData().getSeries().size();
	s = chart.getChartData().getCategories().size();

	// Adding new series
	chart.getChartData().getSeries()
		.add(fact.getCell(defaultWorksheetIndex, 0, 1, "Series 1"), chart.getType());
	chart.getChartData().getSeries()
		.add(fact.getCell(defaultWorksheetIndex, 0, 2, "Series 2"), chart.getType());

	// Adding new categories
	chart.getChartData().getCategories()
		.add(fact.getCell(defaultWorksheetIndex, 1, 0, "Caetegoty 1"));
	chart.getChartData().getCategories()
		.add(fact.getCell(defaultWorksheetIndex, 2, 0, "Caetegoty 2"));
	chart.getChartData().getCategories()
		.add(fact.getCell(defaultWorksheetIndex, 3, 0, "Caetegoty 3"));

	// Take first chart series
	IChartSeries series = chart.getChartData().getSeries().get_Item(0);

	// Now populating series data

	series.getDataPoints().addDataPointForBarSeries(
		fact.getCell(defaultWorksheetIndex, 1, 1, 20));
	series.getDataPoints().addDataPointForBarSeries(
		fact.getCell(defaultWorksheetIndex, 2, 1, 50));
	series.getDataPoints().addDataPointForBarSeries(
		fact.getCell(defaultWorksheetIndex, 3, 1, 30));

	// Setting fill color for series
	series.getFormat().getFill().setFillType(FillType.Solid);
	series.getFormat().getFill().getSolidFillColor().setColor(Color.RED);

	// Take second chart series
	series = chart.getChartData().getSeries().get_Item(1);

	// Now populating series data
	series.getDataPoints().addDataPointForBarSeries(
		fact.getCell(defaultWorksheetIndex, 1, 2, 30));
	series.getDataPoints().addDataPointForBarSeries(
		fact.getCell(defaultWorksheetIndex, 2, 2, 10));
	series.getDataPoints().addDataPointForBarSeries(
		fact.getCell(defaultWorksheetIndex, 3, 2, 60));

	// Setting fill color for series
	series.getFormat().getFill().setFillType(FillType.Solid);
	series.getFormat().getFill().getSolidFillColor().setColor(Color.GREEN);

	// create custom labels for each of categories for new series
	// first label will be show Category name
	IDataLabel lbl = series.getDataPoints().get_Item(0).getLabel();
	lbl.getDataLabelFormat().setShowCategoryName(true);

	lbl = series.getDataPoints().get_Item(1).getLabel();
	lbl.getDataLabelFormat().setShowSeriesName(true);

	// Show value for third label
	lbl = series.getDataPoints().get_Item(2).getLabel();
	lbl.getDataLabelFormat().setShowValue(true);
	lbl.getDataLabelFormat().setShowSeriesName(true);
	lbl.getDataLabelFormat().setSeparator("/");

	// Save presentation with chart
	pres.save(dataPath + "AsposeChart.pptx", SaveFormat.Pptx);
	System.out.println("Done");
    }
}